www.gusucode.com > XerCMS 携云PHP企业建站程序 v2015PHP源码程序 > XerCMS 携云PHP企业建站程序 v2015/XerCMS_v20150724/XerCMS_v20150724/XerCMS/Utils/tables/XerCMS_message.php
<?php /** * @name XERCMS * @author Arno <XerCMS@163.com> [QQ:1328013] * @version 1.0.0 * @link http://www.XerCMS.com */ !defined('XERCMS') && exit('Access Denied'); class TABLE_message extends resource { private $data = NULL; private $defaultTable = 'xercms_message'; function __construct() { $this->table = $this->defaultTable; } function view($id,$uid = 0) { $uid = empty($uid) ? X::$G['uid'] : $uid; DB::update('xercms_member_message',array('state'=>1),array('uid'=>$uid,'id'=>$id)); return DB::result('SELECT m.*,p.nick as sender FROM xercms_member_message m,xercms_member_profile p WHERE p.uid = m.uid and m.uid = '.$uid.' and m.id = '.$id.' LIMIT 1'); } function del($ids,$uid = 0) { $uid = empty($uid) ? X::$G['uid'] : $uid; return DB::query('DELETE FROM xercms_member_message WHERE id in ('.$ids.') AND uid = '.X::$G['uid']); } function count($sate = '0,1',$uid = 0) { $state = explode(',',$state); foreach($state as $k=>$v) { $state[$k] = (int)$v; } $state = implode(',',$state); $uid = empty($uid) ? X::$G['uid'] : $uid; return DB::result_first('SELECT count(*) FROM xercms_member_message WHERE uid = '.X::$G['uid'].' AND state in ('.$state.')'); } function read($page,$state = '0,1',$number = 30,$uid = 0) { $uid = empty($uid) ? X::$G['uid'] : $uid; $state = explode(',',$state); foreach($state as $k=>$v) { $state[$k] = (int)$v; } $state = implode(',',$state); //exit('SELECT m.*,p.nick as sender FROM xercms_member_message m,xercms_member_profile p WHERE p.uid = m.uid and m.uid = '.X::$G['uid'].' limit '.(($page-1)*$number).','.$number); return DB::fetch_all('SELECT m.*,p.nick as sender FROM xercms_member_message m LEFT JOIN xercms_member_profile p ON p.uid = m.uid and m.uid = '.X::$G['uid'].' WHERE m.state in ('.$state.') limit '.(($page-1)*$number).','.$number); } function rely($id,$uid = 0) { $uid = empty($uid) ? X::$G['uid'] : $uid; return DB::result('SELECT title,send FROM xercms_member_message WHERE uid = '.X::$G['uid'].' AND id = '.$id); } } ?>